Skip to main content
TrustRadius
SingleStore

SingleStore
Formerly MemSQL

Overview

What is SingleStore?

SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB, which combines transactional + analytical workloads in a single platform.

Read more
Recent Reviews
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Nir Levy | TrustRadius Reviewer
Nir Levy
VP R&D, DevOps, and Products
Zoomd Technologies (Information Technology & Services, 51-200 employees)
Verified User
C-Level Executive in Engineering
Information Technology & Services Company, 1-10 employees
Return to navigation

Pricing

View all pricing

OnDemand

$0.69

Cloud
per hour

Entry-level set up fee?

  • Setup fee optional
For the latest information on pricing, visithttp://www.memsql.com/pricing

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Details

What is SingleStore?

The world’s leading brands rely on data to make the right business decisions, to deliver exceptional customer experiences, and to stay ahead of the competition. This reliance on data brings with it a need for simplicity, speed, and scale. SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB. By combining transactional + analytical workloads, the vendor states that SingleStore eliminates performance bottlenecks and unnecessary data movement to support constantly growing, demanding workloads. Customers spanning every vertical, including many Fortune 500/Global 2000/Inc.5000 brands, choose SingleStore to unleash the power of their data and supercharge real-time data experiences for their customers.

SingleStore Videos

The World's Fastest Database for Data-Intensive Applications
The Real-Time Revolutionorld's Fastest Database for Data-Intensive Applications
Data-Intensive Applications in Action
Building a Database for Real-Time Applications
A Customer's Big Data Journey From One to Many Products Under a Single Platform

SingleStore Integrations

SingleStore Competitors

SingleStore Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsLinux
Mobile ApplicationNo
Supported CountriesGlobal
Supported LanguagesEnglish

SingleStore Downloadables

Frequently Asked Questions

SingleStore aims to deliver the world’s fastest distributed SQL database for data-intensive applications: SingleStoreDB, which combines transactional + analytical workloads in a single platform.

Oracle Database, Microsoft SQL Server, and MongoDB are common alternatives for SingleStore.

Reviewers rate Performance highest, with a score of 9.9.

The most common users of SingleStore are from Small Businesses (1-50 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(89)

Attribute Ratings

Reviews

(1-6 of 6)
Companies can't remove reviews or game the system. Here's why
February 27, 2024

SingleStore - Blazing Fast Database Service

Verified User
Engineer in Information Technology
Marketing & Advertising Company, 11-50 employees
Score 10 out of 10
Vetted Review
Verified User
Use Cases and Deployment Scope
We use SingleStore for our various web apps. We were previously using AWS RDS which was slowing things down as we added more data and added more analytics, queries, and data enrichment tasks. Moving to SingleStore removed all of those bottlenecks.
Pros and Cons
  • Performance - from 60 to 1,000 requests/min
  • Scalability - grows as we grow
  • Processing - predictive algorithms went from taking 48 hrs down to 15 min
  • Customer Service - monthly touchpoints
  • SSO integration was initially challenging - they are already improving this
  • Cost - each tier literally doubles in price. It would be nice if there was some discounting as you go up.
Likelihood to Recommend
Business analytics is one of the areas where SingleStore really helped. As we implemented BI platforms, the previous DB would bog down so bad that it negatively affected our online products. Moving to SingleStore made a huge difference. General performance is amazing. We gained speed in areas we were not even expecting to the point we had to slow down or put rate limits in place to avoid duplications - something completely unexpected. The hosted service is great. We no longer have to worry about maintenance, db infrastructure or system updates which saves a significant amount of time for the IT team.
February 15, 2024

SingleStore is more reliable, faster at half the cost

Verified User
Team Lead in Engineering
Research Company, 51-200 employees
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
We use it as our analytical database. It is more reliable and faster than our previous vendor. It also allowed us to replace another service that frees up $1500/month. We retrieve thousands of records at a time quickly.
Pros and Cons
  • Delivering thousands of records at blazing fast speeds
  • full text search
  • scaling
  • Improved UI for their portal
  • Better ticket system
  • More workers on workspace
Likelihood to Recommend
Reliable, scales and you can do full text search across the data. Customer support ticketing system could be improved but it's barely a con
December 01, 2022

Great product, amazing team

Verified User
C-Level Executive in Engineering
Publishing Company, 11-50 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
It's our main data store. SingleStore replaced MySQL, PostgreSQL, Redis and Elasticsearch. It's being used for OLAP, OLTP, search and cache at the same time.
SingleStore has seriously decreased our infrastructure complexity, allowing us to move faster and with more confidence.
It has also allowed us to decrease infrastructure cost.
Pros and Cons
  • Mixing OLAP and OLTP in the same cluster
  • Support and customer success team really is great
  • OLAP performance
  • Predictable performance scaling with cluster resources
  • **Much** better monitoring
  • Alerting
  • Smaller clusters offerings
  • More granular scaling
  • Better search features
  • Multi language support for search
  • Slow query visibility and analysis in real production workload
Likelihood to Recommend
It has transformed into my go to database software. The only scenario in which I wouldn't use or recommend it, is if their base managed cluster is too expensive and I don't want to managed it myself
May 16, 2021

SingleStore as the backbone for our data analytics platform.

Verified User
Professional in Research & Development
Information Technology & Services Company, 1-10 employees
Score 9 out of 10
Vetted Review
Reseller
Use Cases and Deployment Scope
SingleStore as the backbone for our Data Analytics platform

With SingleStore, we are able to replace multiple other databases and started migrating from on-premise to SAAS. As SingleStore provides both scenarios, the migration to the cloud will be a smart and simple one. We now use SingleStore for our data and analytics environment. As we now can use the pipelines towards our data lakes and send data via procedures into our tables, we have achieved the next step in our data management by adding additional metadata during the ingestion. Using text search and the geospatial functions adds more functionality than we had before in our previous databases. The performance and scalability are beyond our expectations.

  • The scenario to migrate on-premise and scale up to the cloud as a SAAS.
  • Using HTAP means we can now use our database for transactions and analytics.
  • The main language is similar to MYSQL, so our organization has already the knowledge to master the system.
  • The SingleStore academy is a good program to support our organization to master the environment.
Pros and Cons
  • Performance on large sets of data for analytics.
  • Row based and column based can be used and mixed.
  • Time series, geo spatial and text search function to add to our platform.
  • Scalability, so we can continue to deliver the same performance.
  • Does not yet support foreign keys.
Likelihood to Recommend
Migrating existing databases to one instance, accelerate and scale-out existing data warehouses/analytics platforms. Replace HIVE for SingleStore, which will boost your overall performance and support your data management. Get ready for the cloud by using it on-premise, your own cloud/data center, or as a SAAS. The functionality is the same and migrating will be smooth.
December 15, 2020

Maximum performance and scalability in one.

Jacob Ortega | TrustRadius Reviewer
Jacob Ortega
Chief Technology Officer
albo (Financial Services, 201-500 employees)
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
Right now we’re using [SingleStore (formerly MemSQL)] in the whole core platform, we were looking for a database that could handle a huge amount of transactions at the same time without loosing any and have the reliability of writing and storing the records fast so other services can use the data for finalizing the transactions. Also we were aiming to have a product which could be used as a storage solution for Data Scientists and our back office platform.
Pros and Cons
  • The fastest speed for querying compared with traditional relational database
  • Support JSON and full text search which can be used by API’s
  • Nearly zero admin tasks once it’s running
  • You can use it’s data streaming pipeline with Kafka
  • It doesn’t provide redistribution when you reach the maximum node capacity
  • The Graphical Interface could have a revamp, it’s a little bit laggy
  • You cannot run it local so development should be made always using cloud instances
Likelihood to Recommend
I think SingleStore [(formerly MemSQL)] should be used in every modern system which needs an analytical tool provided with the database, where performance matters and when you need fast scaling. The database is going to use a lot of resources so if the scenario is cost sensitive then perhaps is not the best solution in terms of infrastructure.
September 24, 2020

SingleStore DB (formerly MemSQL) never fails you

Verified User
Team Lead in Information Technology
Government Relations Company, 51-200 employees
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Use Cases and Deployment Scope
We use SingleStore DB (formerly MemSQL) to store a real-time feed of all kinds of open source data. The data get full-text indexed, stored in start schema, and instantly ready for analysis. Multiple departments have access to multiple dashboards backed up with SingleStore DB (formerly MemSQL).
Pros and Cons
  • Ingesting high volume of data in real-time.
  • Excellent query performance (response in milliseconds).
  • Feature rich, json support, full-text search.
  • Minimum administration is needed.
  • Cross-cluster queries
  • SingleStore DB (formerly MemSQL) procedural SQL syntax can be simplified
  • Materialized views
  • Implementing recursion in queries
  • Tag cloud generator from a full-text index
Likelihood to Recommend
SingleStore DB (formerly MemSQL) is good for a high-volume, real-time data feed, a high number of concurrent queries, and excellent for both OLAP and OLTP workloads. It's not good for unstructured data store.
Return to navigation